Prerequisites

Before you can use Microsoft Azure Synapse Analytics as a data warehouse in a Qlik Compose project, make sure that the following prerequisites have been met:

Install the Required ODBC driver

Install SQL Server Native Client 11 on the Compose machine.

Using Microsoft Entra ID (Active Directory) authentication with the JDBC driver

When connecting via the JDBC driver and authenticating using Microsoft Entra ID (formerly known as Active Directory authentication), the following files need to be added to the [COMPOSE-INSTALL-DIR]\java\jdbc folder. After adding the files, you need to restart the Qlik Compose service.

• mssql-jdbc-12.8.1.jre11.jar
• msal4j-1.15.1.jar
• jackson-databind-2.13.4.2.jar
• jackson-annotations-2.13.4.jar
• jackson-core-2.13.4.jar
• oauth2-oidc-sdk -11.9.1.jar
• jcip-annotations-1.0-1.jar
• content-type-2.3.jar
• lang-tag-1.7.jar
• nimbus-jose-jwt-9.37.3.jar
• json-smart-2.5.0.jar
• accessors-smart-2.5.0.jar
• asm-9.3.jar
• slf4j- api-1.7.36.jar

Permissions

The user specified in the Microsoft Azure Synapse Analytics connection settings must be granted the following permissions.

Permission required for the specified target database:

The Compose must be granted the db_owner user role on the specified target database.

Permission required for the master database:

The Compose must be granted SELECT access (by adding the user to the master database and then to the db_readers role, for example).

Open the Required Firewall Port(s)

• When Compose runs on a machine outside Azure - Open port 1433 for outbound traffic.
• When Compose runs on an AzureVM - Open the following ports for outbound traffic:
  • 1433
  • 11000-11999
  • 14000-14999